<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.9.1"/>
<title>OCILIB (C and C++ Driver for Oracle): Timestamps and intervals manipulation</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtreedata.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
  $(window).load(resizeHeight);
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td style="padding-left: 0.5em;">
   <div id="projectname">OCILIB (C and C++ Driver for Oracle)
   &#160;<span id="projectnumber">4.2.1</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.9.1 -->
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>About</span></a></li>
      <li><a href="modules.html"><span>Documentation</span></a></li>
      <li><a href="namespaces.html"><span>Namespaces</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li><a href="files.html"><span>Files</span></a></li>
    </ul>
  </div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('group___ocilib_c_api_timestamps.html','');});
</script>
<div id="doc-content">
<div class="header">
  <div class="summary">
<a href="#func-members">Functions</a>  </div>
  <div class="headertitle">
<div class="title">Timestamps and intervals manipulation<div class="ingroups"><a class="el" href="group___ocilib_c_api.html">C API</a></div></div>  </div>
</div><!--header-->
<div class="contents">
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<p>OCILIB encapsulates Oracle :</p>
<ul>
<li>SQL timestamp data type within OCI_Timestamp structure</li>
<li>SQL interval data type within OCI_Interval structure</li>
</ul>
<p>Basically, the OCI_Timestamp and OCI_Interval routines are wrappers around the Oracle OCIDatetime and OCIInterval APIs</p>
<dl class="section user"><dt>Examples</dt><dd><div class="fragment"><div class="line"><span class="preprocessor">#include &quot;ocilib.h&quot;</span></div>
<div class="line"> </div>
<div class="line"><span class="preprocessor">#define SIZE_STR 260</span></div>
<div class="line"></div>
<div class="line"><span class="keywordtype">int</span> main(<span class="keywordtype">void</span>)</div>
<div class="line">{</div>
<div class="line">    <a class="code" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tm;</div>
<div class="line">    <a class="code" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv;</div>
<div class="line"></div>
<div class="line">    <span class="keywordtype">char</span> str[SIZE_STR+1];</div>
<div class="line">   </div>
<div class="line">    <span class="keywordflow">if</span> (!<a class="code" href="group___ocilib_c_api_initialization.html#ga01464863ddd68393106b63fb8cc1ead1">OCI_Initialize</a>(NULL, NULL, OCI_ENV_DEFAULT))</div>
<div class="line">        <span class="keywordflow">return</span> EXIT_FAILURE;</div>
<div class="line"></div>
<div class="line">    tm  = <a class="code" href="group___ocilib_c_api_timestamps.html#ga5c590ea371920703997cd7bea126ad9d">OCI_TimestampCreate</a>(NULL, OCI_TIMESTAMP);</div>
<div class="line">    itv = <a class="code" href="group___ocilib_c_api_timestamps.html#ga4748278cf01c5e927137ce3342038fd7">OCI_IntervalCreate</a>(NULL, OCI_INTERVAL_DS);</div>
<div class="line"></div>
<div class="line">    OCI_TimestampSysTimeStamp(tm);</div>
<div class="line">    <a class="code" href="group___ocilib_c_api_timestamps.html#gaa03bff2809c77cfa152c18aca8f12ea0">OCI_TimestampToText</a>(tm, <span class="stringliteral">&quot;DD/MM/YYYY HH24:MI:SS:FF3&quot;</span>, SIZE_STR, str, 3);</div>
<div class="line">    printf(<span class="stringliteral">&quot;%s\n&quot;</span>, str);</div>
<div class="line"></div>
<div class="line">    <a class="code" href="group___ocilib_c_api_timestamps.html#ga5fa498aad5bf6a1b2bd899a0f054432a">OCI_IntervalSetDaySecond</a>(itv, 1,1,1,1,0);</div>
<div class="line">    <a class="code" href="group___ocilib_c_api_timestamps.html#ga082b6dd7a028234b87c3e7efc94fe598">OCI_IntervalToText</a>(itv, 10, 10, SIZE_STR, str);</div>
<div class="line">    printf(<span class="stringliteral">&quot;%s\n&quot;</span>, str);</div>
<div class="line">   </div>
<div class="line">    <a class="code" href="group___ocilib_c_api_timestamps.html#ga43028a0463f25bcd9665993a244572e7">OCI_TimestampIntervalAdd</a>(tm, itv);</div>
<div class="line">    <a class="code" href="group___ocilib_c_api_timestamps.html#gaa03bff2809c77cfa152c18aca8f12ea0">OCI_TimestampToText</a>(tm, <span class="stringliteral">&quot;DD/MM/YYYY HH24:MI:SS:FF3&quot;</span>, SIZE_STR, str, 3);</div>
<div class="line">    printf(<span class="stringliteral">&quot;%s\n&quot;</span>, str);</div>
<div class="line"></div>
<div class="line">    <a class="code" href="group___ocilib_c_api_initialization.html#ga639706aa8e9689c7ebffc018fac6d3ae">OCI_Cleanup</a>();</div>
<div class="line"> </div>
<div class="line">    <span class="keywordflow">return</span> EXIT_SUCCESS;</div>
<div class="line">}</div>
</div><!-- fragment --> </dd></dl>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="func-members"></a>
Functions</h2></td></tr>
<tr class="memitem:ga5c590ea371920703997cd7bea126ad9d"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga5c590ea371920703997cd7bea126ad9d">OCI_TimestampCreate</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *con, unsigned int type)</td></tr>
<tr class="memdesc:ga5c590ea371920703997cd7bea126ad9d"><td class="mdescLeft">&#160;</td><td class="mdescRight">Create a local Timestamp instance.  <a href="#ga5c590ea371920703997cd7bea126ad9d">More...</a><br /></td></tr>
<tr class="separator:ga5c590ea371920703997cd7bea126ad9d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga60e9851db1175d6b650f9df00db274da"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga60e9851db1175d6b650f9df00db274da">OCI_TimestampFree</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp)</td></tr>
<tr class="memdesc:ga60e9851db1175d6b650f9df00db274da"><td class="mdescLeft">&#160;</td><td class="mdescRight">Free an OCI_Timestamp handle.  <a href="#ga60e9851db1175d6b650f9df00db274da">More...</a><br /></td></tr>
<tr class="separator:ga60e9851db1175d6b650f9df00db274da"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gac28ac3b866c7aa7ded5cbdc77a222f83"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> **OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gac28ac3b866c7aa7ded5cbdc77a222f83">OCI_TimestampArrayCreate</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *con, unsigned int type, unsigned int nbelem)</td></tr>
<tr class="memdesc:gac28ac3b866c7aa7ded5cbdc77a222f83"><td class="mdescLeft">&#160;</td><td class="mdescRight">Create an array of timestamp object.  <a href="#gac28ac3b866c7aa7ded5cbdc77a222f83">More...</a><br /></td></tr>
<tr class="separator:gac28ac3b866c7aa7ded5cbdc77a222f83"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gaedda6bfe74ad6938f32ab9f41e92de77"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gaedda6bfe74ad6938f32ab9f41e92de77">OCI_TimestampArrayFree</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> **tmsps)</td></tr>
<tr class="memdesc:gaedda6bfe74ad6938f32ab9f41e92de77"><td class="mdescLeft">&#160;</td><td class="mdescRight">Free an array of timestamp objects.  <a href="#gaedda6bfe74ad6938f32ab9f41e92de77">More...</a><br /></td></tr>
<tr class="separator:gaedda6bfe74ad6938f32ab9f41e92de77"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gaa6a59f18f308bd55841654bd66c6cee6"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT unsigned int OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gaa6a59f18f308bd55841654bd66c6cee6">OCI_TimestampGetType</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp)</td></tr>
<tr class="memdesc:gaa6a59f18f308bd55841654bd66c6cee6"><td class="mdescLeft">&#160;</td><td class="mdescRight">Return the type of the given Timestamp object.  <a href="#gaa6a59f18f308bd55841654bd66c6cee6">More...</a><br /></td></tr>
<tr class="separator:gaa6a59f18f308bd55841654bd66c6cee6"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga6b8356c2fcaa984d2d63edd5cc7a357b"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga6b8356c2fcaa984d2d63edd5cc7a357b">OCI_TimestampAssign</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp_src)</td></tr>
<tr class="memdesc:ga6b8356c2fcaa984d2d63edd5cc7a357b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assign the value of a timestamp handle to another one.  <a href="#ga6b8356c2fcaa984d2d63edd5cc7a357b">More...</a><br /></td></tr>
<tr class="separator:ga6b8356c2fcaa984d2d63edd5cc7a357b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gab23aaba98e752b92725045205bd55a03"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT int OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gab23aaba98e752b92725045205bd55a03">OCI_TimestampCheck</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp)</td></tr>
<tr class="memdesc:gab23aaba98e752b92725045205bd55a03"><td class="mdescLeft">&#160;</td><td class="mdescRight">Check if the given timestamp is valid.  <a href="#gab23aaba98e752b92725045205bd55a03">More...</a><br /></td></tr>
<tr class="separator:gab23aaba98e752b92725045205bd55a03"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga8063cc410dc2ed2a80aa9a434e759b0b"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT int OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga8063cc410dc2ed2a80aa9a434e759b0b">OCI_TimestampCompare</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp2)</td></tr>
<tr class="memdesc:ga8063cc410dc2ed2a80aa9a434e759b0b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Compares two timestamp handles.  <a href="#ga8063cc410dc2ed2a80aa9a434e759b0b">More...</a><br /></td></tr>
<tr class="separator:ga8063cc410dc2ed2a80aa9a434e759b0b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga69ff607811120e46a8b794652561584d"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga69ff607811120e46a8b794652561584d">OCI_TimestampConstruct</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, int year, int month, int day, int hour, int min, int sec, int fsec, const otext *time_zone)</td></tr>
<tr class="memdesc:ga69ff607811120e46a8b794652561584d"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set a timestamp handle value.  <a href="#ga69ff607811120e46a8b794652561584d">More...</a><br /></td></tr>
<tr class="separator:ga69ff607811120e46a8b794652561584d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga7eec8396448c7466944fd37d7386bc89"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga7eec8396448c7466944fd37d7386bc89">OCI_TimestampConvert</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp_src)</td></tr>
<tr class="memdesc:ga7eec8396448c7466944fd37d7386bc89"><td class="mdescLeft">&#160;</td><td class="mdescRight">Convert one timestamp value from one type to another.  <a href="#ga7eec8396448c7466944fd37d7386bc89">More...</a><br /></td></tr>
<tr class="separator:ga7eec8396448c7466944fd37d7386bc89"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga12e5a27ee3fe733a9443b2270ce53d3d"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga12e5a27ee3fe733a9443b2270ce53d3d">OCI_TimestampFromText</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, const otext *str, const otext *fmt)</td></tr>
<tr class="memdesc:ga12e5a27ee3fe733a9443b2270ce53d3d"><td class="mdescLeft">&#160;</td><td class="mdescRight">Convert a string to a timestamp and store it in the given timestamp handle.  <a href="#ga12e5a27ee3fe733a9443b2270ce53d3d">More...</a><br /></td></tr>
<tr class="separator:ga12e5a27ee3fe733a9443b2270ce53d3d"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gaa03bff2809c77cfa152c18aca8f12ea0"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gaa03bff2809c77cfa152c18aca8f12ea0">OCI_TimestampToText</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, const otext *fmt, int size, otext *str, int precision)</td></tr>
<tr class="memdesc:gaa03bff2809c77cfa152c18aca8f12ea0"><td class="mdescLeft">&#160;</td><td class="mdescRight">Convert a timestamp value from the given timestamp handle to a string.  <a href="#gaa03bff2809c77cfa152c18aca8f12ea0">More...</a><br /></td></tr>
<tr class="separator:gaa03bff2809c77cfa152c18aca8f12ea0"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gae8b95bad27ed1bce2e9753e30d3fa26b"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gae8b95bad27ed1bce2e9753e30d3fa26b">OCI_TimestampGetDate</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, int *year, int *month, int *day)</td></tr>
<tr class="memdesc:gae8b95bad27ed1bce2e9753e30d3fa26b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Extract the date part from a timestamp handle.  <a href="#gae8b95bad27ed1bce2e9753e30d3fa26b">More...</a><br /></td></tr>
<tr class="separator:gae8b95bad27ed1bce2e9753e30d3fa26b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga4c56996d6dc31b7a4373daa0018c88e1"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga4c56996d6dc31b7a4373daa0018c88e1">OCI_TimestampGetTime</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, int *hour, int *min, int *sec, int *fsec)</td></tr>
<tr class="memdesc:ga4c56996d6dc31b7a4373daa0018c88e1"><td class="mdescLeft">&#160;</td><td class="mdescRight">Extract the time portion from a timestamp handle.  <a href="#ga4c56996d6dc31b7a4373daa0018c88e1">More...</a><br /></td></tr>
<tr class="separator:ga4c56996d6dc31b7a4373daa0018c88e1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga364aa28b777ed77ac6c66b7dd95926e8"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga364aa28b777ed77ac6c66b7dd95926e8">OCI_TimestampGetDateTime</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, int *year, int *month, int *day, int *hour, int *min, int *sec, int *fsec)</td></tr>
<tr class="memdesc:ga364aa28b777ed77ac6c66b7dd95926e8"><td class="mdescLeft">&#160;</td><td class="mdescRight">Extract the date and time parts from a date handle.  <a href="#ga364aa28b777ed77ac6c66b7dd95926e8">More...</a><br /></td></tr>
<tr class="separator:ga364aa28b777ed77ac6c66b7dd95926e8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gaebf760ad7eb58cc4f21fe360af1f933e"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gaebf760ad7eb58cc4f21fe360af1f933e">OCI_TimestampGetTimeZoneName</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, int size, otext *str)</td></tr>
<tr class="memdesc:gaebf760ad7eb58cc4f21fe360af1f933e"><td class="mdescLeft">&#160;</td><td class="mdescRight">Return the time zone name of a timestamp handle.  <a href="#gaebf760ad7eb58cc4f21fe360af1f933e">More...</a><br /></td></tr>
<tr class="separator:gaebf760ad7eb58cc4f21fe360af1f933e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga807ca5a3e663b234945f9a018e88badb"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga807ca5a3e663b234945f9a018e88badb">OCI_TimestampGetTimeZoneOffset</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, int *hour, int *min)</td></tr>
<tr class="memdesc:ga807ca5a3e663b234945f9a018e88badb"><td class="mdescLeft">&#160;</td><td class="mdescRight">Return the time zone (hour, minute) portion of a timestamp handle.  <a href="#ga807ca5a3e663b234945f9a018e88badb">More...</a><br /></td></tr>
<tr class="separator:ga807ca5a3e663b234945f9a018e88badb"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga43028a0463f25bcd9665993a244572e7"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga43028a0463f25bcd9665993a244572e7">OCI_TimestampIntervalAdd</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv)</td></tr>
<tr class="memdesc:ga43028a0463f25bcd9665993a244572e7"><td class="mdescLeft">&#160;</td><td class="mdescRight">Add an interval value to a timestamp value of a timestamp handle.  <a href="#ga43028a0463f25bcd9665993a244572e7">More...</a><br /></td></tr>
<tr class="separator:ga43028a0463f25bcd9665993a244572e7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gaa3353b2e9b5ed9e7ffa2019e9232246c"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gaa3353b2e9b5ed9e7ffa2019e9232246c">OCI_TimestampIntervalSub</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv)</td></tr>
<tr class="memdesc:gaa3353b2e9b5ed9e7ffa2019e9232246c"><td class="mdescLeft">&#160;</td><td class="mdescRight">Subtract an interval value from a timestamp value of a timestamp handle.  <a href="#gaa3353b2e9b5ed9e7ffa2019e9232246c">More...</a><br /></td></tr>
<tr class="separator:gaa3353b2e9b5ed9e7ffa2019e9232246c"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gae97028efa9db15ea51db83a8dd27de56"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gae97028efa9db15ea51db83a8dd27de56">OCI_TimestampSubtract</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp2, <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv)</td></tr>
<tr class="memdesc:gae97028efa9db15ea51db83a8dd27de56"><td class="mdescLeft">&#160;</td><td class="mdescRight">Store the difference of two timestamp handles into an interval handle.  <a href="#gae97028efa9db15ea51db83a8dd27de56">More...</a><br /></td></tr>
<tr class="separator:gae97028efa9db15ea51db83a8dd27de56"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gac7b03ef399746fd49a3eae096c0b108f"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gac7b03ef399746fd49a3eae096c0b108f">OCI_TimestampSysTimestamp</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp)</td></tr>
<tr class="memdesc:gac7b03ef399746fd49a3eae096c0b108f"><td class="mdescLeft">&#160;</td><td class="mdescRight">Stores the system current date and time as a timestamp value with time zone into the timestamp handle.  <a href="#gac7b03ef399746fd49a3eae096c0b108f">More...</a><br /></td></tr>
<tr class="separator:gac7b03ef399746fd49a3eae096c0b108f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga5b38e5b80794e324b17adf60dc851b03"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga5b38e5b80794e324b17adf60dc851b03">OCI_TimestampToCTime</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, struct tm *ptm, time_t *pt)</td></tr>
<tr class="memdesc:ga5b38e5b80794e324b17adf60dc851b03"><td class="mdescLeft">&#160;</td><td class="mdescRight">Affect an OCI_Timestamp handle value to ISO C time data types.  <a href="#ga5b38e5b80794e324b17adf60dc851b03">More...</a><br /></td></tr>
<tr class="separator:ga5b38e5b80794e324b17adf60dc851b03"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga69f6172371a6a70fcecb2c4e1d34a360"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga69f6172371a6a70fcecb2c4e1d34a360">OCI_TimestampFromCTime</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *tmsp, struct tm *ptm, time_t t)</td></tr>
<tr class="memdesc:ga69f6172371a6a70fcecb2c4e1d34a360"><td class="mdescLeft">&#160;</td><td class="mdescRight">Affect ISO C time data types values to an OCI_Timestamp handle.  <a href="#ga69f6172371a6a70fcecb2c4e1d34a360">More...</a><br /></td></tr>
<tr class="separator:ga69f6172371a6a70fcecb2c4e1d34a360"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga4748278cf01c5e927137ce3342038fd7"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga4748278cf01c5e927137ce3342038fd7">OCI_IntervalCreate</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *con, unsigned int type)</td></tr>
<tr class="memdesc:ga4748278cf01c5e927137ce3342038fd7"><td class="mdescLeft">&#160;</td><td class="mdescRight">Create a local interval object.  <a href="#ga4748278cf01c5e927137ce3342038fd7">More...</a><br /></td></tr>
<tr class="separator:ga4748278cf01c5e927137ce3342038fd7"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga7623b368ab3486c15c6d671054fac3e3"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga7623b368ab3486c15c6d671054fac3e3">OCI_IntervalFree</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv)</td></tr>
<tr class="memdesc:ga7623b368ab3486c15c6d671054fac3e3"><td class="mdescLeft">&#160;</td><td class="mdescRight">Free an OCI_Interval handle.  <a href="#ga7623b368ab3486c15c6d671054fac3e3">More...</a><br /></td></tr>
<tr class="separator:ga7623b368ab3486c15c6d671054fac3e3"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gae47749bf85fc87f4e14897385f567ab1"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> **OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gae47749bf85fc87f4e14897385f567ab1">OCI_IntervalArrayCreate</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *con, unsigned int type, unsigned int nbelem)</td></tr>
<tr class="memdesc:gae47749bf85fc87f4e14897385f567ab1"><td class="mdescLeft">&#160;</td><td class="mdescRight">Create an array of Interval object.  <a href="#gae47749bf85fc87f4e14897385f567ab1">More...</a><br /></td></tr>
<tr class="separator:gae47749bf85fc87f4e14897385f567ab1"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga955bdb6c9155f3ebef94bfe089fa2b28"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga955bdb6c9155f3ebef94bfe089fa2b28">OCI_IntervalArrayFree</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> **itvs)</td></tr>
<tr class="memdesc:ga955bdb6c9155f3ebef94bfe089fa2b28"><td class="mdescLeft">&#160;</td><td class="mdescRight">Free an array of Interval objects.  <a href="#ga955bdb6c9155f3ebef94bfe089fa2b28">More...</a><br /></td></tr>
<tr class="separator:ga955bdb6c9155f3ebef94bfe089fa2b28"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga29704a6c17b3938c63988edc6364907e"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT unsigned int OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga29704a6c17b3938c63988edc6364907e">OCI_IntervalGetType</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv)</td></tr>
<tr class="memdesc:ga29704a6c17b3938c63988edc6364907e"><td class="mdescLeft">&#160;</td><td class="mdescRight">Return the type of the given Interval object.  <a href="#ga29704a6c17b3938c63988edc6364907e">More...</a><br /></td></tr>
<tr class="separator:ga29704a6c17b3938c63988edc6364907e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga479e6e2db5d78dee2b396190c577019a"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga479e6e2db5d78dee2b396190c577019a">OCI_IntervalAssign</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv_src)</td></tr>
<tr class="memdesc:ga479e6e2db5d78dee2b396190c577019a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Assign the value of a interval handle to another one.  <a href="#ga479e6e2db5d78dee2b396190c577019a">More...</a><br /></td></tr>
<tr class="separator:ga479e6e2db5d78dee2b396190c577019a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga2f89edaeae7952774fff0cc0366e635f"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT int OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga2f89edaeae7952774fff0cc0366e635f">OCI_IntervalCheck</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv)</td></tr>
<tr class="memdesc:ga2f89edaeae7952774fff0cc0366e635f"><td class="mdescLeft">&#160;</td><td class="mdescRight">Check if the given interval is valid.  <a href="#ga2f89edaeae7952774fff0cc0366e635f">More...</a><br /></td></tr>
<tr class="separator:ga2f89edaeae7952774fff0cc0366e635f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga136738d0987078d8ef34c9cfc109e63f"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT int OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga136738d0987078d8ef34c9cfc109e63f">OCI_IntervalCompare</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv2)</td></tr>
<tr class="memdesc:ga136738d0987078d8ef34c9cfc109e63f"><td class="mdescLeft">&#160;</td><td class="mdescRight">Compares two interval handles.  <a href="#ga136738d0987078d8ef34c9cfc109e63f">More...</a><br /></td></tr>
<tr class="separator:ga136738d0987078d8ef34c9cfc109e63f"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gac0083e94933f563b5b707f97dd376cd9"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gac0083e94933f563b5b707f97dd376cd9">OCI_IntervalFromText</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, const otext *str)</td></tr>
<tr class="memdesc:gac0083e94933f563b5b707f97dd376cd9"><td class="mdescLeft">&#160;</td><td class="mdescRight">Convert a string to an interval and store it in the given interval handle.  <a href="#gac0083e94933f563b5b707f97dd376cd9">More...</a><br /></td></tr>
<tr class="separator:gac0083e94933f563b5b707f97dd376cd9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga082b6dd7a028234b87c3e7efc94fe598"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga082b6dd7a028234b87c3e7efc94fe598">OCI_IntervalToText</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, int leading_prec, int fraction_prec, int size, otext *str)</td></tr>
<tr class="memdesc:ga082b6dd7a028234b87c3e7efc94fe598"><td class="mdescLeft">&#160;</td><td class="mdescRight">Convert an interval value from the given interval handle to a string.  <a href="#ga082b6dd7a028234b87c3e7efc94fe598">More...</a><br /></td></tr>
<tr class="separator:ga082b6dd7a028234b87c3e7efc94fe598"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga15f6f417e4d5ad0da007f26ab6f6a6d3"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga15f6f417e4d5ad0da007f26ab6f6a6d3">OCI_IntervalFromTimeZone</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, const otext *str)</td></tr>
<tr class="memdesc:ga15f6f417e4d5ad0da007f26ab6f6a6d3"><td class="mdescLeft">&#160;</td><td class="mdescRight">Correct an interval handle value with the given time zone.  <a href="#ga15f6f417e4d5ad0da007f26ab6f6a6d3">More...</a><br /></td></tr>
<tr class="separator:ga15f6f417e4d5ad0da007f26ab6f6a6d3"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga165e94c916375ea604737a2348c4d83b"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga165e94c916375ea604737a2348c4d83b">OCI_IntervalGetDaySecond</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, int *day, int *hour, int *min, int *sec, int *fsec)</td></tr>
<tr class="memdesc:ga165e94c916375ea604737a2348c4d83b"><td class="mdescLeft">&#160;</td><td class="mdescRight">Return the day / time portion of an interval handle.  <a href="#ga165e94c916375ea604737a2348c4d83b">More...</a><br /></td></tr>
<tr class="separator:ga165e94c916375ea604737a2348c4d83b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:gaf0632925b430ad8ff145e29936b7b592"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#gaf0632925b430ad8ff145e29936b7b592">OCI_IntervalGetYearMonth</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, int *year, int *month)</td></tr>
<tr class="memdesc:gaf0632925b430ad8ff145e29936b7b592"><td class="mdescLeft">&#160;</td><td class="mdescRight">Return the year / month portion of an interval handle.  <a href="#gaf0632925b430ad8ff145e29936b7b592">More...</a><br /></td></tr>
<tr class="separator:gaf0632925b430ad8ff145e29936b7b592"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga5fa498aad5bf6a1b2bd899a0f054432a"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga5fa498aad5bf6a1b2bd899a0f054432a">OCI_IntervalSetDaySecond</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, int day, int hour, int min, int sec, int fsec)</td></tr>
<tr class="memdesc:ga5fa498aad5bf6a1b2bd899a0f054432a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the day / time portion if the given interval handle.  <a href="#ga5fa498aad5bf6a1b2bd899a0f054432a">More...</a><br /></td></tr>
<tr class="separator:ga5fa498aad5bf6a1b2bd899a0f054432a"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga05a06f783659c6652c38319688d77526"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga05a06f783659c6652c38319688d77526">OCI_IntervalSetYearMonth</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, int year, int month)</td></tr>
<tr class="memdesc:ga05a06f783659c6652c38319688d77526"><td class="mdescLeft">&#160;</td><td class="mdescRight">Set the year / month portion if the given Interval handle.  <a href="#ga05a06f783659c6652c38319688d77526">More...</a><br /></td></tr>
<tr class="separator:ga05a06f783659c6652c38319688d77526"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga7065230b2482155997928190cdef6ab8"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga7065230b2482155997928190cdef6ab8">OCI_IntervalAdd</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv2)</td></tr>
<tr class="memdesc:ga7065230b2482155997928190cdef6ab8"><td class="mdescLeft">&#160;</td><td class="mdescRight">Adds an interval handle value to another.  <a href="#ga7065230b2482155997928190cdef6ab8">More...</a><br /></td></tr>
<tr class="separator:ga7065230b2482155997928190cdef6ab8"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ga6e0044488c4abb1111f7c1173aed8877"><td class="memItemLeft" align="right" valign="top">OCI_EXPORT boolean OCI_API&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="group___ocilib_c_api_timestamps.html#ga6e0044488c4abb1111f7c1173aed8877">OCI_IntervalSubtract</a> (<a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv, <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *itv2)</td></tr>
<tr class="memdesc:ga6e0044488c4abb1111f7c1173aed8877"><td class="mdescLeft">&#160;</td><td class="mdescRight">Subtract an interval handle value from another.  <a href="#ga6e0044488c4abb1111f7c1173aed8877">More...</a><br /></td></tr>
<tr class="separator:ga6e0044488c4abb1111f7c1173aed8877"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<h2 class="groupheader">Function Documentation</h2>
<a class="anchor" id="ga5c590ea371920703997cd7bea126ad9d"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a>* OCI_API OCI_TimestampCreate </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *&#160;</td>
          <td class="paramname"><em>con</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&#160;</td>
          <td class="paramname"><em>type</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Create a local Timestamp instance. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">con</td><td>- Connection handle </td></tr>
    <tr><td class="paramname">type</td><td>- Timestamp type</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>From version 2.5.0, parameter 'con' can be NULL in order to manipulate timestamps independently from database connections</dd>
<dd>
Timestamp type can be :</dd></dl>
<ul>
<li>OCI_TIMESTAMP : timestamp</li>
<li>OCI_TIMESTAMP_TZ : timestamp with time zone</li>
<li>OCI_TIMESTAMP_LTZ : timestamp with local time zone</li>
</ul>
<dl class="section return"><dt>Returns</dt><dd>Return the Timestamp handle on success otherwise NULL on failure </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a26bf87f4efcc477c77b0b34a703a49bd">ocilib::Timestamp::Timestamp()</a>.</p>

</div>
</div>
<a class="anchor" id="ga60e9851db1175d6b650f9df00db274da"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampFree </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Free an OCI_Timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section warning"><dt>Warning</dt><dd>Only Timestamp created with <a class="el" href="group___ocilib_c_api_timestamps.html#ga5c590ea371920703997cd7bea126ad9d" title="Create a local Timestamp instance. ">OCI_TimestampCreate()</a> should be freed by <a class="el" href="group___ocilib_c_api_timestamps.html#ga7623b368ab3486c15c6d671054fac3e3" title="Free an OCI_Interval handle. ">OCI_IntervalFree()</a></dd></dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a26bf87f4efcc477c77b0b34a703a49bd">ocilib::Timestamp::Timestamp()</a>.</p>

</div>
</div>
<a class="anchor" id="gac28ac3b866c7aa7ded5cbdc77a222f83"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a>** OCI_API OCI_TimestampArrayCreate </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *&#160;</td>
          <td class="paramname"><em>con</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&#160;</td>
          <td class="paramname"><em>type</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&#160;</td>
          <td class="paramname"><em>nbelem</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Create an array of timestamp object. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">con</td><td>- Connection handle </td></tr>
    <tr><td class="paramname">type</td><td>- Timestamp type </td></tr>
    <tr><td class="paramname">nbelem</td><td>- number of elements in the array</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>see <a class="el" href="group___ocilib_c_api_timestamps.html#ga5c590ea371920703997cd7bea126ad9d" title="Create a local Timestamp instance. ">OCI_TimestampCreate()</a> for more details</dd></dl>
<dl class="section return"><dt>Returns</dt><dd>Return the timestamp handle array on success otherwise NULL on failure </dd></dl>

</div>
</div>
<a class="anchor" id="gaedda6bfe74ad6938f32ab9f41e92de77"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampArrayFree </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> **&#160;</td>
          <td class="paramname"><em>tmsps</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Free an array of timestamp objects. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsps</td><td>- Array of timestamp objects</td></tr>
  </table>
  </dd>
</dl>
<dl class="section warning"><dt>Warning</dt><dd>Only arrays of timestamp created with <a class="el" href="group___ocilib_c_api_timestamps.html#gac28ac3b866c7aa7ded5cbdc77a222f83" title="Create an array of timestamp object. ">OCI_TimestampArrayCreate()</a> should be freed by <a class="el" href="group___ocilib_c_api_timestamps.html#gaedda6bfe74ad6938f32ab9f41e92de77" title="Free an array of timestamp objects. ">OCI_TimestampArrayFree()</a></dd></dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

</div>
</div>
<a class="anchor" id="gaa6a59f18f308bd55841654bd66c6cee6"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_TimestampGetType </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Return the type of the given Timestamp object. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>For possible values, see <a class="el" href="group___ocilib_c_api_timestamps.html#ga5c590ea371920703997cd7bea126ad9d" title="Create a local Timestamp instance. ">OCI_TimestampCreate()</a></dd></dl>
<dl class="section return"><dt>Returns</dt><dd>Object type or OCI_UNKNOWN the input handle is NULL </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a30ec0d01c890ce792096863094d22e26">ocilib::Timestamp::GetType()</a>.</p>

</div>
</div>
<a class="anchor" id="ga6b8356c2fcaa984d2d63edd5cc7a357b"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampAssign </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp_src</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Assign the value of a timestamp handle to another one. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Destination Timestamp handle </td></tr>
    <tr><td class="paramname">tmsp_src</td><td>- Source Timestamp handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#af92cf8ecfffd3fc166552da654237cb0">ocilib::Timestamp::Clone()</a>.</p>

</div>
</div>
<a class="anchor" id="gab23aaba98e752b92725045205bd55a03"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT int OCI_API OCI_TimestampCheck </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Check if the given timestamp is valid. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd><ul>
<li>Zero if the timestamp value is valid</li>
<li>Any other value means the timestamp value is invalid </li>
</ul>
</dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a01751990c96e4a1bda54482262d3eb6c">ocilib::Timestamp::IsValid()</a>.</p>

</div>
</div>
<a class="anchor" id="ga8063cc410dc2ed2a80aa9a434e759b0b"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT int OCI_API OCI_TimestampCompare </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp2</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Compares two timestamp handles. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp1 handle </td></tr>
    <tr><td class="paramname">tmsp2</td><td>- Timestamp2 handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd><ul>
<li>-1 if Timestamp1 is smaller than Timestamp2,</li>
<li>0 if they are equal</li>
<li>1 if Timestamp1 is greater than Timestamp2. </li>
</ul>
</dd></dl>

</div>
</div>
<a class="anchor" id="ga69ff607811120e46a8b794652561584d"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampConstruct </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>year</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>month</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>day</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>hour</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>min</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>fsec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const otext *&#160;</td>
          <td class="paramname"><em>time_zone</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Set a timestamp handle value. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">year</td><td>- Year value </td></tr>
    <tr><td class="paramname">month</td><td>- Month value </td></tr>
    <tr><td class="paramname">day</td><td>- Day value </td></tr>
    <tr><td class="paramname">hour</td><td>- hour value </td></tr>
    <tr><td class="paramname">min</td><td>- minutes value </td></tr>
    <tr><td class="paramname">sec</td><td>- seconds value </td></tr>
    <tr><td class="paramname">fsec</td><td>- fractional part of seconds value </td></tr>
    <tr><td class="paramname">time_zone</td><td>- name of a time zone to use [optional]</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a96e0e68871acbe91a926d6ef84422492">ocilib::Timestamp::SetDateTime()</a>.</p>

</div>
</div>
<a class="anchor" id="ga7eec8396448c7466944fd37d7386bc89"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampConvert </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp_src</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Convert one timestamp value from one type to another. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle to convert </td></tr>
    <tr><td class="paramname">tmsp_src</td><td>- Timestamp handle to use for the type conversion</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a4d62cd5546ed652ae4b04533f243f0a9">ocilib::Timestamp::Convert()</a>.</p>

</div>
</div>
<a class="anchor" id="ga12e5a27ee3fe733a9443b2270ce53d3d"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampFromText </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const otext *&#160;</td>
          <td class="paramname"><em>str</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const otext *&#160;</td>
          <td class="paramname"><em>fmt</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Convert a string to a timestamp and store it in the given timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Destination Timestamp handle </td></tr>
    <tr><td class="paramname">str</td><td>- Source date string </td></tr>
    <tr><td class="paramname">fmt</td><td>- Date format</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a59e2d47ed21416bae572dddebc1d64fd">ocilib::Timestamp::FromString()</a>.</p>

</div>
</div>
<a class="anchor" id="gaa03bff2809c77cfa152c18aca8f12ea0"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampToText </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const otext *&#160;</td>
          <td class="paramname"><em>fmt</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>size</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">otext *&#160;</td>
          <td class="paramname"><em>str</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>precision</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Convert a timestamp value from the given timestamp handle to a string. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- source Timestamp handle </td></tr>
    <tr><td class="paramname">fmt</td><td>- Timestamp format </td></tr>
    <tr><td class="paramname">size</td><td>- Destination string size in characters </td></tr>
    <tr><td class="paramname">str</td><td>- Destination date string </td></tr>
    <tr><td class="paramname">precision</td><td>- Precision for fractional part of the seconds</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a37856fb40c55d86839b6dccf21218497">ocilib::Timestamp::ToString()</a>.</p>

</div>
</div>
<a class="anchor" id="gae8b95bad27ed1bce2e9753e30d3fa26b"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampGetDate </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>year</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>month</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>day</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Extract the date part from a timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">year</td><td>- Place holder for year value </td></tr>
    <tr><td class="paramname">month</td><td>- Place holder for month value </td></tr>
    <tr><td class="paramname">day</td><td>- Place holder for day value</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a5d325442b400d32a2c9833405438b7a8">ocilib::Timestamp::GetDate()</a>.</p>

</div>
</div>
<a class="anchor" id="ga4c56996d6dc31b7a4373daa0018c88e1"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampGetTime </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>hour</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>min</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>sec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>fsec</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Extract the time portion from a timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">hour</td><td>- Place holder for hour value </td></tr>
    <tr><td class="paramname">min</td><td>- Place holder for minute value </td></tr>
    <tr><td class="paramname">sec</td><td>- Place holder for second value </td></tr>
    <tr><td class="paramname">fsec</td><td>- Place holder for fractional part of second value</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a83721afeb57b65511af4032d4fba5411">ocilib::Timestamp::GetTime()</a>.</p>

</div>
</div>
<a class="anchor" id="ga364aa28b777ed77ac6c66b7dd95926e8"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampGetDateTime </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>year</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>month</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>day</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>hour</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>min</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>sec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>fsec</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Extract the date and time parts from a date handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Date handle </td></tr>
    <tr><td class="paramname">year</td><td>- Place holder for year value </td></tr>
    <tr><td class="paramname">month</td><td>- Place holder for month value </td></tr>
    <tr><td class="paramname">day</td><td>- Place holder for day value </td></tr>
    <tr><td class="paramname">hour</td><td>- Place holder for hour value </td></tr>
    <tr><td class="paramname">min</td><td>- Place holder for minute value </td></tr>
    <tr><td class="paramname">sec</td><td>- Place holder for second value </td></tr>
    <tr><td class="paramname">fsec</td><td>- Place holder for fractional part of seconds value</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a5a18c4d359594ffacc5434f1fa2b8f5c">ocilib::Timestamp::GetDateTime()</a>.</p>

</div>
</div>
<a class="anchor" id="gaebf760ad7eb58cc4f21fe360af1f933e"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampGetTimeZoneName </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>size</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">otext *&#160;</td>
          <td class="paramname"><em>str</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Return the time zone name of a timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">size</td><td>- Destination string size in characters </td></tr>
    <tr><td class="paramname">str</td><td>- Destination zone name string</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a77807966b9b29833dd8a595d50467b4b">ocilib::Timestamp::GetTimeZone()</a>.</p>

</div>
</div>
<a class="anchor" id="ga807ca5a3e663b234945f9a018e88badb"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampGetTimeZoneOffset </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>hour</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>min</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Return the time zone (hour, minute) portion of a timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">hour</td><td>- Place holder for hour value </td></tr>
    <tr><td class="paramname">min</td><td>- Place holder for min value</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#ae33ac792c314322954c29dffc8cce171">ocilib::Timestamp::GetTimeZoneOffset()</a>.</p>

</div>
</div>
<a class="anchor" id="ga43028a0463f25bcd9665993a244572e7"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampIntervalAdd </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Add an interval value to a timestamp value of a timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">itv</td><td>- Interval handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#ab9ace45cf7bd568178b5afadf159fb5f">ocilib::Timestamp::operator+=()</a>.</p>

</div>
</div>
<a class="anchor" id="gaa3353b2e9b5ed9e7ffa2019e9232246c"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampIntervalSub </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Subtract an interval value from a timestamp value of a timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">itv</td><td>- Interval handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#aea8c09eef2dd09305e9df4161b9672f6">ocilib::Timestamp::operator-=()</a>.</p>

</div>
</div>
<a class="anchor" id="gae97028efa9db15ea51db83a8dd27de56"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampSubtract </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp2</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Store the difference of two timestamp handles into an interval handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle (subtrahend) </td></tr>
    <tr><td class="paramname">tmsp2</td><td>- Timestamp2 handle (minuend) </td></tr>
    <tr><td class="paramname">itv</td><td>- Interval handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>The function acts like tmsp - tmsp2 = itv</dd></dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#a459393b361378de2fe1c77c9af469cd8">ocilib::Timestamp::operator-()</a>, and <a class="el" href="classocilib_1_1_timestamp.html#aee56ee27d7b8c3f694ceb53346caac6a">ocilib::Timestamp::Substract()</a>.</p>

</div>
</div>
<a class="anchor" id="gac7b03ef399746fd49a3eae096c0b108f"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampSysTimestamp </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Stores the system current date and time as a timestamp value with time zone into the timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_timestamp.html#ab4e620bbb5f5843447254da1505dfbc1">ocilib::Timestamp::SysTimestamp()</a>.</p>

</div>
</div>
<a class="anchor" id="ga5b38e5b80794e324b17adf60dc851b03"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampToCTime </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">struct tm *&#160;</td>
          <td class="paramname"><em>ptm</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">time_t *&#160;</td>
          <td class="paramname"><em>pt</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Affect an OCI_Timestamp handle value to ISO C time data types. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">ptm</td><td>- Pointer to a structure tm to receive date/time values </td></tr>
    <tr><td class="paramname">pt</td><td>- Pointer to a time_t to hold the date/time in the time_t format</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>Both parameters 'ptm' and 'p' are optional but one of them has to be provided.</dd></dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

</div>
</div>
<a class="anchor" id="ga69f6172371a6a70fcecb2c4e1d34a360"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_TimestampFromCTime </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga51bd3b406fe1b1d1a2eceee3f02ebd47">OCI_Timestamp</a> *&#160;</td>
          <td class="paramname"><em>tmsp</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">struct tm *&#160;</td>
          <td class="paramname"><em>ptm</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">time_t&#160;</td>
          <td class="paramname"><em>t</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Affect ISO C time data types values to an OCI_Timestamp handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">tmsp</td><td>- Timestamp handle </td></tr>
    <tr><td class="paramname">ptm</td><td>- Pointer to a structure tm that hold the date/time value </td></tr>
    <tr><td class="paramname">t</td><td>- Value (time_t) that hold the date/time in the time_t format</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>Both parameters 'ptm' and 'p' are optional but one of them has to be provided. If 'ptm' is not null, its value is affected to the OCI_Timestamp handle, otherwise the value of 't' is used.</dd></dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

</div>
</div>
<a class="anchor" id="ga4748278cf01c5e927137ce3342038fd7"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a>* OCI_API OCI_IntervalCreate </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *&#160;</td>
          <td class="paramname"><em>con</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&#160;</td>
          <td class="paramname"><em>type</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Create a local interval object. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">con</td><td>- Connection handle </td></tr>
    <tr><td class="paramname">type</td><td>- Type of Interval</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>From version 2.5.0, parameter 'con' can be NULL in order to manipulate intervals independently from database connections</dd>
<dd>
Interval type can be :<ul>
<li>OCI_INTERVAL_YM : year / month interval</li>
<li>OCI_INTERVAL_DS : date/ time interval</li>
</ul>
</dd></dl>
<dl class="section return"><dt>Returns</dt><dd>Return the Interval handle on success otherwise NULL on failure </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a58549d5f7914cbcab99db43e9fd493fc">ocilib::Interval::Interval()</a>.</p>

</div>
</div>
<a class="anchor" id="ga7623b368ab3486c15c6d671054fac3e3"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalFree </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Free an OCI_Interval handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section warning"><dt>Warning</dt><dd>Only Intervals created with <a class="el" href="group___ocilib_c_api_timestamps.html#ga4748278cf01c5e927137ce3342038fd7" title="Create a local interval object. ">OCI_IntervalCreate()</a> should be freed by <a class="el" href="group___ocilib_c_api_timestamps.html#ga7623b368ab3486c15c6d671054fac3e3" title="Free an OCI_Interval handle. ">OCI_IntervalFree()</a></dd></dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a58549d5f7914cbcab99db43e9fd493fc">ocilib::Interval::Interval()</a>.</p>

</div>
</div>
<a class="anchor" id="gae47749bf85fc87f4e14897385f567ab1"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a>** OCI_API OCI_IntervalArrayCreate </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#ga2135d3b5341ebbaae1f54d62873ecf77">OCI_Connection</a> *&#160;</td>
          <td class="paramname"><em>con</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&#160;</td>
          <td class="paramname"><em>type</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&#160;</td>
          <td class="paramname"><em>nbelem</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Create an array of Interval object. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">con</td><td>- Connection handle </td></tr>
    <tr><td class="paramname">type</td><td>- Type of Interval </td></tr>
    <tr><td class="paramname">nbelem</td><td>- number of elements in the array</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>see <a class="el" href="group___ocilib_c_api_timestamps.html#ga4748278cf01c5e927137ce3342038fd7" title="Create a local interval object. ">OCI_IntervalCreate()</a> for more details</dd></dl>
<dl class="section return"><dt>Returns</dt><dd>Return the Interval handle array on success otherwise NULL on failure </dd></dl>

</div>
</div>
<a class="anchor" id="ga955bdb6c9155f3ebef94bfe089fa2b28"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalArrayFree </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> **&#160;</td>
          <td class="paramname"><em>itvs</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Free an array of Interval objects. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itvs</td><td>- Array of Interval objects</td></tr>
  </table>
  </dd>
</dl>
<dl class="section warning"><dt>Warning</dt><dd>Only arrays of Interval created with <a class="el" href="group___ocilib_c_api_timestamps.html#gae47749bf85fc87f4e14897385f567ab1" title="Create an array of Interval object. ">OCI_IntervalArrayCreate()</a> should be freed by <a class="el" href="group___ocilib_c_api_timestamps.html#ga955bdb6c9155f3ebef94bfe089fa2b28" title="Free an array of Interval objects. ">OCI_IntervalArrayFree()</a></dd></dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

</div>
</div>
<a class="anchor" id="ga29704a6c17b3938c63988edc6364907e"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_IntervalGetType </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Return the type of the given Interval object. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section note"><dt>Note</dt><dd>For possible values, see <a class="el" href="group___ocilib_c_api_timestamps.html#ga4748278cf01c5e927137ce3342038fd7" title="Create a local interval object. ">OCI_IntervalCreate()</a></dd></dl>
<dl class="section return"><dt>Returns</dt><dd>Object type or OCI_UNKNOWN the input handle is NULL </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a7d15fa0d2c99b69d8ea4d7ed53e64d32">ocilib::Interval::GetType()</a>.</p>

</div>
</div>
<a class="anchor" id="ga479e6e2db5d78dee2b396190c577019a"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalAssign </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv_src</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Assign the value of a interval handle to another one. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Destination interval handle </td></tr>
    <tr><td class="paramname">itv_src</td><td>- Source interval handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#ae6f2f3fbc2f22bc04f81d3b9202b6287">ocilib::Interval::Clone()</a>.</p>

</div>
</div>
<a class="anchor" id="ga2f89edaeae7952774fff0cc0366e635f"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT int OCI_API OCI_IntervalCheck </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Check if the given interval is valid. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd><ul>
<li>Zero if the interval value is valid</li>
<li>Any other value means the interval value is invalid </li>
</ul>
</dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a52e654415020440efe002e9e3979ab84">ocilib::Interval::IsValid()</a>.</p>

</div>
</div>
<a class="anchor" id="ga136738d0987078d8ef34c9cfc109e63f"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT int OCI_API OCI_IntervalCompare </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv2</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Compares two interval handles. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval1 handle </td></tr>
    <tr><td class="paramname">itv2</td><td>- Interval2 handle</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd><ul>
<li>-1 if interval1 is smaller than interval2,</li>
<li>0 if they are equal</li>
<li>1 if interval1 is greater than interval2. </li>
</ul>
</dd></dl>

</div>
</div>
<a class="anchor" id="gac0083e94933f563b5b707f97dd376cd9"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalFromText </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const otext *&#160;</td>
          <td class="paramname"><em>str</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Convert a string to an interval and store it in the given interval handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Destination interval handle </td></tr>
    <tr><td class="paramname">str</td><td>- Source date string</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#af81dd9b7ee637dd4dbd6926ea0a8eff9">ocilib::Interval::FromString()</a>.</p>

</div>
</div>
<a class="anchor" id="ga082b6dd7a028234b87c3e7efc94fe598"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalToText </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>leading_prec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>fraction_prec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>size</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">otext *&#160;</td>
          <td class="paramname"><em>str</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Convert an interval value from the given interval handle to a string. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- source Interval handle </td></tr>
    <tr><td class="paramname">leading_prec</td><td>- Precision of the leading part </td></tr>
    <tr><td class="paramname">fraction_prec</td><td>- Precision of the fractional part </td></tr>
    <tr><td class="paramname">size</td><td>- Destination string size in characters </td></tr>
    <tr><td class="paramname">str</td><td>- Destination date string</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a15e309ec7726e0d23a043c227cc5367c">ocilib::Interval::ToString()</a>.</p>

</div>
</div>
<a class="anchor" id="ga15f6f417e4d5ad0da007f26ab6f6a6d3"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalFromTimeZone </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">const otext *&#160;</td>
          <td class="paramname"><em>str</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Correct an interval handle value with the given time zone. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle </td></tr>
    <tr><td class="paramname">str</td><td>- Time zone name</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#ac678c97f4b51f284e5fcccc924f427c5">ocilib::Interval::UpdateTimeZone()</a>.</p>

</div>
</div>
<a class="anchor" id="ga165e94c916375ea604737a2348c4d83b"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalGetDaySecond </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>day</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>hour</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>min</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>sec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>fsec</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Return the day / time portion of an interval handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle </td></tr>
    <tr><td class="paramname">day</td><td>- Place holder for day value </td></tr>
    <tr><td class="paramname">hour</td><td>- Place holder for hours value </td></tr>
    <tr><td class="paramname">min</td><td>- Place holder for minutes value </td></tr>
    <tr><td class="paramname">sec</td><td>- Place holder for seconds value </td></tr>
    <tr><td class="paramname">fsec</td><td>- Place holder for fractional part of seconds value</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a1916f941acd4320593bf89fd5b1b7cd7">ocilib::Interval::GetDaySecond()</a>.</p>

</div>
</div>
<a class="anchor" id="gaf0632925b430ad8ff145e29936b7b592"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalGetYearMonth </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>year</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int *&#160;</td>
          <td class="paramname"><em>month</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Return the year / month portion of an interval handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle </td></tr>
    <tr><td class="paramname">year</td><td>- Place holder for year value </td></tr>
    <tr><td class="paramname">month</td><td>- Place holder for month value</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a7b91ed3a04b40f5172a91fb83e152ac2">ocilib::Interval::GetYearMonth()</a>.</p>

</div>
</div>
<a class="anchor" id="ga5fa498aad5bf6a1b2bd899a0f054432a"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalSetDaySecond </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>day</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>hour</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>min</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>sec</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>fsec</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Set the day / time portion if the given interval handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle </td></tr>
    <tr><td class="paramname">day</td><td>- day value </td></tr>
    <tr><td class="paramname">hour</td><td>- Hour value </td></tr>
    <tr><td class="paramname">min</td><td>- Minute value </td></tr>
    <tr><td class="paramname">sec</td><td>- Second value </td></tr>
    <tr><td class="paramname">fsec</td><td>- Fractional part of the seconds</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#acffb79cc4979cee7e49938a957177dba">ocilib::Interval::SetDaySecond()</a>.</p>

</div>
</div>
<a class="anchor" id="ga05a06f783659c6652c38319688d77526"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalSetYearMonth </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>year</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">int&#160;</td>
          <td class="paramname"><em>month</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Set the year / month portion if the given Interval handle. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle </td></tr>
    <tr><td class="paramname">year</td><td>- Year value </td></tr>
    <tr><td class="paramname">month</td><td>- Month value</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#ad4bae20d7e87eb57526dab3d4303c6de">ocilib::Interval::SetYearMonth()</a>.</p>

</div>
</div>
<a class="anchor" id="ga7065230b2482155997928190cdef6ab8"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalAdd </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv2</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Adds an interval handle value to another. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle from witch to add </td></tr>
    <tr><td class="paramname">itv2</td><td>- Interval handle to add</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#a0d543fb59b6ab3b23a4b48d9b48c6e65">ocilib::Interval::operator+=()</a>.</p>

</div>
</div>
<a class="anchor" id="ga6e0044488c4abb1111f7c1173aed8877"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_IntervalSubtract </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype"><a class="el" href="group___ocilib_c_api_datatypes.html#gac15e42323f4e24403bb2ff5dce7e054c">OCI_Interval</a> *&#160;</td>
          <td class="paramname"><em>itv2</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p><code>#include &lt;ocilib.h&gt;</code></p>

<p>Subtract an interval handle value from another. </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">itv</td><td>- Interval handle from witch to remove </td></tr>
    <tr><td class="paramname">itv2</td><td>- Interval handle to remove</td></tr>
  </table>
  </dd>
</dl>
<dl class="section return"><dt>Returns</dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Referenced by <a class="el" href="classocilib_1_1_interval.html#ac92ddd1c7e219f1d88af4abc8e58d43f">ocilib::Interval::operator-=()</a>.</p>

</div>
</div>
</div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="footer">Generated on Mon Mar 21 2016 22:26:37 for OCILIB (C and C++ Driver for Oracle) by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.9.1 </li>
  </ul>
</div>
</body>
</html>
